UPDATE C1_OPERATE_LOG t SET t.end_date= sysdate WHERE t.code = :code AND t.end_date > sysdate AND EXISTS
(SELECT 1 FROM c1_dictionary e WHERE e.id = t.type_id AND e.code = :typeCode
)
